package com.atkxp.stustatusmasystem.mapper;

import com.atkxp.stustatusmasystem.pojo.Course;
import com.atkxp.stustatusmasystem.pojo.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.boot.web.embedded.undertow.ConfigurableUndertowWebServerFactory;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * @author user
 * @declaration
 * @create 2023/5/24-19:49
 */
@Repository
@Mapper
public interface StudentMapper {
    List<Student> getAllStudents();

    List<Student> getAllStudentsByTid(String tid);

    Long getStudentCountByTid(String tid);

    Long getStudentCount();

    Student queryStuBySidAndPassword(@Param("sid") String sid, @Param("password") String password);

    List<Course> getAllCoursesBySidAndSyear(Map msg);

    int addStudent(Student student);

    int deleteStudentById(int id);

    int updateStudentById(Student student);

    Student getStudentById(int id);
}
